UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ydFPZPWq7MzrUQb/iU0vJxzLtqqiYRAGXnY80qgSkh4='
WHERE
key_id = '7bf949aeec27788c9727caf968b7f85fb795e1260e9b940e54654e15ed0233a1'
AND (
token = 'ydFPZPWq7MzrUQb/iU0vJxzLtqqiYRAGXnY80qgSkh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)