UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vR9sX/b0gvikYqgNlE9yKucWR5RrUvcn7BZ8iutaOYs='
WHERE
key_id = '21d1530923340e727012f98721e2a4409eaa2231c0037419fd7772f56791fd1c'
AND (
token = 'vR9sX/b0gvikYqgNlE9yKucWR5RrUvcn7BZ8iutaOYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)