UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgKFn8KAX8il0hEC84DUaN5Yxa2uAKnQsLDoBAcZIsg='
WHERE
key_id = '97af6b82334a2867823e0046fde140a6cb396d2fbb543256b97897c357d27743'
AND (
token = 'BgKFn8KAX8il0hEC84DUaN5Yxa2uAKnQsLDoBAcZIsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)