UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ljsP6WrkGYSZPUvsF3WrxtLDbi8JQ6WEV24XE0RvwUU='
WHERE
key_id = '62cfdea47b8a5b495c585e8874e921885d7b52e39be28993aae1fce2bad9607a'
AND (
token = 'ljsP6WrkGYSZPUvsF3WrxtLDbi8JQ6WEV24XE0RvwUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)