UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fHVhBsVXhTQinWaHW3P0T0rqeUsCxgs7UNIlqqPotmE='
WHERE
key_id = '00162974036775490f97f976e648b6be10f69d8a31a0e32f9083787b8ba855e7'
AND (
token = 'fHVhBsVXhTQinWaHW3P0T0rqeUsCxgs7UNIlqqPotmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)