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