UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0XoDRtj1lKU66YLn044CjbYvgYkAsQo0HOFjSfSgkAE='
WHERE
key_id = '31fea7a5df9d1f0dd6e13c0358fa071391932a297d0cb86b1b16300fbce92172'
AND (
token = '0XoDRtj1lKU66YLn044CjbYvgYkAsQo0HOFjSfSgkAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)