UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7t3w2WSjNqQBHUS6vyvHzv3PjCJ8ZiVwRn1PAcsNTHA='
WHERE
key_id = '95170a83b43ea8b568401a7dd62f280308377f8404fdb35b10579cccd9e3583b'
AND (
token = '7t3w2WSjNqQBHUS6vyvHzv3PjCJ8ZiVwRn1PAcsNTHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)