UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+mjxwilGwXiLqx9sTi6WDu2JjpL5CiHxA6SZ4/T0NQ='
WHERE
key_id = '27a2f148e720c47eb5d618cc8e994a36b6edd759c24df18af8b329d6a89ebd00'
AND (
token = 'r+mjxwilGwXiLqx9sTi6WDu2JjpL5CiHxA6SZ4/T0NQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)