UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LI9oZbu7qIve6ZqthGmnaAODPQr2G0qiC38hL5l7Aug='
WHERE
key_id = '816cb92ec1165144cfd721c859fcbeadb8d5da7c797fc5fa0e65a76b037dce1c'
AND (
token = 'LI9oZbu7qIve6ZqthGmnaAODPQr2G0qiC38hL5l7Aug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)