UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ylk0WoHhuq0sS8aBapCUPOfnGK5/L7yCMyx46uXHVxA='
WHERE
key_id = '9c9514d7045916f22783b509cb2310aba17f14592fa3bdb738f45db7d57570f6'
AND (
token = 'Ylk0WoHhuq0sS8aBapCUPOfnGK5/L7yCMyx46uXHVxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)