UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zaIpTK2kvFyONN1JIDCtlZZD/ZKRJNqBs5nWJWjpSa0='
WHERE
key_id = '99977e472efd790b8ee1fb06e056aa6f99320372345db5f669b3ae6eba27b9bc'
AND (
token = 'zaIpTK2kvFyONN1JIDCtlZZD/ZKRJNqBs5nWJWjpSa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)