UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IDZnLiDC3hVo4d1JMyFOmey4cADi0E/9mICrLke65Bo='
WHERE
key_id = '49bccb02fcfbf470e5f7c404aeff5e7b2dbe89cbf583cfce4ffb03c5a9ebb96d'
AND (
token = 'IDZnLiDC3hVo4d1JMyFOmey4cADi0E/9mICrLke65Bo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)