UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZcgVTqs6laglKxVOgZa3YUc4tUgNS2k8s5/LbDNFrY='
WHERE
key_id = 'ee838d4abff7222fe3881856bf1813b63b20ec23db672d9c7bd92c7c4bffbf6b'
AND (
token = 'zZcgVTqs6laglKxVOgZa3YUc4tUgNS2k8s5/LbDNFrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)