UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CThH8IU+3vk/GbjWavzqcVKUFwnwleuXYGVOSVNsAow='
WHERE
key_id = '41c12f541e033f7c6f87444b76d7a8eda79c296c4e6ab7318e1f34918a7810ff'
AND (
token = 'CThH8IU+3vk/GbjWavzqcVKUFwnwleuXYGVOSVNsAow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)