UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RD8+orxxBRFWHgYsbBF7d5rir6t1BsSmI9iFn2n5R84='
WHERE
key_id = 'c30907ee362303fe9b0af6e342c385dbb36729b687c3f8d7b5b96cdca461493b'
AND (
token = 'RD8+orxxBRFWHgYsbBF7d5rir6t1BsSmI9iFn2n5R84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)