UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KAbgh0U1M2zQto9IMVXAB4VN6FzZHIxotb72quU15so='
WHERE
key_id = 'f23c31af311cd34fa6cbf0a3c19366f32d269a2d47b287793bd6051dcd71b9cb'
AND (
token = 'KAbgh0U1M2zQto9IMVXAB4VN6FzZHIxotb72quU15so='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)