UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THg5r6WzMQb9g6fh/7+zAJ2/4OmRadoJe0tMFKIwtPc='
WHERE
key_id = '0479b50e978edeb64776d152e2227da99f62be219458a0a38710287a47d8d3d3'
AND (
token = 'THg5r6WzMQb9g6fh/7+zAJ2/4OmRadoJe0tMFKIwtPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)