UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QiDj4kQE0q9BQTlLgfzb1rqAdzTbgCQQC8I0+9sDxqo='
WHERE
key_id = 'c6df4666bac1e92ff23f6a9987e3dfcfd6de286b2d02dcf1faaa4717308c2862'
AND (
token = 'QiDj4kQE0q9BQTlLgfzb1rqAdzTbgCQQC8I0+9sDxqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)