UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GwmdjJWZh6117OMzeIxRgBw30xe+JjAs+ay9pWIvQoY='
WHERE
key_id = 'c28382a9c3cfd749de702099402f30e89bb3271e1e13f1183fb03ed6dee06d2c'
AND (
token = 'GwmdjJWZh6117OMzeIxRgBw30xe+JjAs+ay9pWIvQoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)