UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EZaJBtWTl3IYWElhDcnxYqYFuJS4vfEwEMk4Agxktlg='
WHERE
key_id = '9a5f1a6c98ad6180156ed99d90e9d0d56d78babab8ea2fd747a6949d0d7f4537'
AND (
token = 'EZaJBtWTl3IYWElhDcnxYqYFuJS4vfEwEMk4Agxktlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)