UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHXjI9kqE7ENWGvvEKQt6zrzXzTHBTzBjYBLvCY4zd4='
WHERE
key_id = 'c4837be091c26b10b8439dcf12c6e4f638651b55d64ebc5a769e2b876cfb4550'
AND (
token = 'hHXjI9kqE7ENWGvvEKQt6zrzXzTHBTzBjYBLvCY4zd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)