UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oxmcN9bpnwlAq/eGhgoAlBYhfa5AQRaJjyjp3S0fvSA='
WHERE
key_id = '1be0875bcb6ce1deeb9b5c91d438d2cd4bf7b3b958814ca4dec2e87d8a24bc4e'
AND (
token = 'oxmcN9bpnwlAq/eGhgoAlBYhfa5AQRaJjyjp3S0fvSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)