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