UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KKziP9ks+6bDz4VQ6aIuLOY676U2yfW64LZHx2xLwr0='
WHERE
key_id = 'cc68b98c08fe38da556539c8d9c24dfd3e141d480c5a93b2f01d149194bb58ff'
AND (
token = 'KKziP9ks+6bDz4VQ6aIuLOY676U2yfW64LZHx2xLwr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)