UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/j0HstgLvUvs1ReAQAjf8UoWrjc0BadvA8yyI6O/8Xw='
WHERE
key_id = '8b149dc0f8b79d03b098ed442c9b205a376b04bbdd1577e95218ad7ee0d39d2a'
AND (
token = '/j0HstgLvUvs1ReAQAjf8UoWrjc0BadvA8yyI6O/8Xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)