UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HfLUVvohLf+NVcL6FFdXWjAwcGUDpiqPm8/1t/fyys0='
WHERE
key_id = 'ce3ecdae86de1594b21325512335418417b4b8338d634125d34d92e36d3bd099'
AND (
token = 'HfLUVvohLf+NVcL6FFdXWjAwcGUDpiqPm8/1t/fyys0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)