UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpBWeWFjaGv7/XRVKvf8qfeSvhrwJvSHchBWbM5z7GA='
WHERE
key_id = 'f496b92084c4244f6152b364dab7d6b5824866d1b11f626a3bfee2b3c36671bc'
AND (
token = 'ZpBWeWFjaGv7/XRVKvf8qfeSvhrwJvSHchBWbM5z7GA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)