UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xlHYpqDb3o9Vir3vYf0Oru3UUjsroa8y5C5xvt3yEXc='
WHERE
key_id = '8ce72b07d7e9790c8316f1e2fb30dc7db5c0ef6a9882b6f47ea0e4aea6120703'
AND (
token = 'xlHYpqDb3o9Vir3vYf0Oru3UUjsroa8y5C5xvt3yEXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)