UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lYSCjXLsHoJoWs3S8b45jxfT2B3p4CsTXZ/BrcRWeQw='
WHERE
key_id = '2e5c35fb1636da21b565658cdfbf87ea2742d83834233cd3a169b81c15a6d74b'
AND (
token = 'lYSCjXLsHoJoWs3S8b45jxfT2B3p4CsTXZ/BrcRWeQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)