UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yl7C9lJVkckpxPWx68DkYyscoeJTxz19ccjuldgI534='
WHERE
key_id = '4bb524768bf47f46d3ecf77c02b11630d2fef83e2c0925dd262de7e60f325e7b'
AND (
token = 'Yl7C9lJVkckpxPWx68DkYyscoeJTxz19ccjuldgI534='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)