UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nqWqwZESRfHzm+vXK0WyBunqbjFg7i9gl5727EA0YO4='
WHERE
key_id = 'e3ae3220c91cea805762d47813a4559492b12ce06139738e113f8a205406a5a9'
AND (
token = 'nqWqwZESRfHzm+vXK0WyBunqbjFg7i9gl5727EA0YO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)