UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wH+R/WUqOAxq/sfRs6iRF/vffqvqyJd/zPnwLG+/4zk='
WHERE
key_id = 'b340c0484ced4dd856e8306e70bde59e7ea88c99d03dd2bf34666f40b038b9cb'
AND (
token = 'wH+R/WUqOAxq/sfRs6iRF/vffqvqyJd/zPnwLG+/4zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)