UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6qL8YjTSRegKwfD1eQcqRyFJX+t83dxc/hXjSCdgPYY='
WHERE
key_id = '289c0f5f5c275fee7c9ace418224a162063f244c63896bf03094f2575735e73b'
AND (
token = '6qL8YjTSRegKwfD1eQcqRyFJX+t83dxc/hXjSCdgPYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)