UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'flUbUMziYA04TqYudnkpz25YhFeudZufiBmjruZUelI='
WHERE
key_id = '93f974c47f0f838c1a09d88e9944e01547f66e6ae8a4bc6e97e37178ee607eea'
AND (
token = 'flUbUMziYA04TqYudnkpz25YhFeudZufiBmjruZUelI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)