UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tI7RCY+iPKdb2kJo/EHH9VfWmwWsqKpfIh71D42Nqpk='
WHERE
key_id = '3c86d0253deebc9ae25b8234bf38a2b269f58bc9f71b2ab4ae23b98d9d89a294'
AND (
token = 'tI7RCY+iPKdb2kJo/EHH9VfWmwWsqKpfIh71D42Nqpk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)