UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5RqItuNgyKgoROjA6wK7cFzBVEF7va3A0uVu+VGUr8M='
WHERE
key_id = '1f871a866a3856930a1cb943dbc5a532a0befce0456869fa51e4873185b4cb39'
AND (
token = '5RqItuNgyKgoROjA6wK7cFzBVEF7va3A0uVu+VGUr8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)