UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6JyXSIZoYLlEDIK8fIx7SqmvVhwe6qgXjAptQ7aKTmM='
WHERE
key_id = 'b1d20adf8ae8f63757d65d64921db1a833c0f9481e162b681c892979f8e46283'
AND (
token = '6JyXSIZoYLlEDIK8fIx7SqmvVhwe6qgXjAptQ7aKTmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)