UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UcCrnqv92B+awoOjZN57mrou/9hn+FhI/6xa4685Pvw='
WHERE
key_id = '2a507ddc84342562f93f58d5c813b658a3de41f7cf0676a7daadaa9a147f1c3e'
AND (
token = 'UcCrnqv92B+awoOjZN57mrou/9hn+FhI/6xa4685Pvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)