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