UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vR64gixKGa+5BnA5PMWAayZc30A2EGjiDMatxNkdknM='
WHERE
key_id = '97b0d0e445abcb579aa62618904c222bb49ca6407f234d8283c5311c188183a5'
AND (
token = 'vR64gixKGa+5BnA5PMWAayZc30A2EGjiDMatxNkdknM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)