UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u0vp272j9VQMJYEihWHdprKzokRheKOQWyQKORm9N1k='
WHERE
key_id = '1fde98dc9843ab34938a0b66a76b4bc30241b665acfc5b4d4314d39ff9c32a98'
AND (
token = 'u0vp272j9VQMJYEihWHdprKzokRheKOQWyQKORm9N1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)