UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QW/PFgPLVnj5z6bIfL98Xh3T4CwC1clRVm1jj6nsnuA='
WHERE
key_id = 'af6ae3533f65146030fe40acf16ee75a93fc95dbad22d543b7445f8ec6b1fdb0'
AND (
token = 'QW/PFgPLVnj5z6bIfL98Xh3T4CwC1clRVm1jj6nsnuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)