UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/hINKpnSHeBSgWRRnTMC8kM5HjY69cpob6lkvy7GhhY='
WHERE
key_id = '8c7a8148b0f31caa31971b634a988f72a9bb09c6c2588af2881b6de72166aff8'
AND (
token = '/hINKpnSHeBSgWRRnTMC8kM5HjY69cpob6lkvy7GhhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)