UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/s+nEKhmrKBwKUoyd+wXeopXCrrVS0syVjygQs9kc8o='
WHERE
key_id = '5e31a350b0fcefeb52a2a55a4cb164add05a9d14b7ae54d178b00a24a2349706'
AND (
token = '/s+nEKhmrKBwKUoyd+wXeopXCrrVS0syVjygQs9kc8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)